Tabela ContractData

Definicja tabeli ContractData

Name

ContractData

Code

ContractData

Comment

 


Lista kolumn tabeli ContractData

Name

Code

ContractDataID

ContractDataID

ContractID

ContractID

ContractServID

ContractServID

ContractNo

ContractNo

UnitsCount

UnitsCount

Price

Price

StartDT

StartDT

StopDT

StopDT

Active

Active

RatioSchema

RatioSchema

DateRestriction

DateRestriction

GrouperVersion

GrouperVersion

IsLumpSumContractService

IsLumpSumContractService


Kolumna ContractDataID tabeli ContractData

Definicja kolumny ContractDataID tabeli ContractData

Name

ContractDataID

Code

ContractDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli ContractData

Definicja kolumny ContractID tabeli ContractData

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServID tabeli ContractData

Definicja kolumny ContractServID tabeli ContractData

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractNo tabeli ContractData

Definicja kolumny ContractNo tabeli ContractData

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli ContractData

Definicja kolumny UnitsCount tabeli ContractData

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna Price tabeli ContractData

Definicja kolumny Price tabeli ContractData

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ContractData

Definicja kolumny StartDT tabeli ContractData

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ContractData

Definicja kolumny StopDT tabeli ContractData

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli ContractData

Definicja kolumny Active tabeli ContractData

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna RatioSchema tabeli ContractData

Definicja kolumny RatioSchema tabeli ContractData

Name

RatioSchema

Code

RatioSchema

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna DateRestriction tabeli ContractData

Definicja kolumny DateRestriction tabeli ContractData

Name

DateRestriction

Code

DateRestriction

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna GrouperVersion tabeli ContractData

Definicja kolumny GrouperVersion tabeli ContractData

Name

GrouperVersion

Code

GrouperVersion

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna IsLumpSumContractService tabeli ContractData

Definicja kolumny IsLumpSumContractService tabeli ContractData

Name

IsLumpSumContractService

Code

IsLumpSumContractService

Data Type

NUMBER(3)

Mandatory

No

Comment

(Flaga) Czy produkt jest ryczaltowy


Lista kluczy tabeli ContractData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractData

Definicja klucza Identifier_1 tabeli ContractData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment